package com.maxatime.dao;

import com.maxatime.pojo.Areas;
import com.maxatime.pojo.Cities;
import com.maxatime.pojo.Provinces;
import com.maxatime.pojo.data.stuInfoData;
import com.maxatime.pojo.studentInformation;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
@Mapper
public interface studentInformationMapper {
    int deleteByPrimaryKey(Integer stuId);

    int insert(studentInformation record);

    int insertSelective(studentInformation record);
    int insertStuExcel(studentInformation record);

    studentInformation selectByPrimaryKey(Integer stuId);

    int updateByPrimaryKeySelective(studentInformation record);

    int updateByPrimaryKey(studentInformation record);

    //全查
    List<studentInformation> findAllqc();
    //模糊查
    List<studentInformation> findAll(studentInformation studentInformation);

    //省下拉框
    List<Provinces> provinces();

    //市下拉框
    List<Cities> cities();

    //县/区下拉框
    List<Areas> areas();

    List<studentInformation> stuexport(studentInformation sVO);

    void inse(List<studentInformation> readResult);

    List<stuInfoData> select();
}